package com.kxq.zhuoyue.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kxq.zhuoyue.pageUtilEntity.BackList;
import com.kxq.zhuoyue.po.ClientHistory;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author xjh
 * @since 2023-09-08
 */
@Mapper
public interface ClientHistoryMapper extends BaseMapper<ClientHistory> {


    @Select("SELECT client_history_id,clients.join_time,client_history.client_id,client_history.emp_id,client_history.create_time,client_history.description,clients.client_status,clients.client_intent,clients.client_description,clients.client_name,clients.client_source,clients.client_sex,clients.customer_label,clients.content_label,clients.client_birthday,emp.emp_name FROM (client_history,clients,emp) WHERE (client_type = '-1' and emp.emp_id=client_history.emp_id and clients.client_id=client_history.client_id)")
    List<BackList> getBackList();
}
